retrieve into temp (t.all,Bunique1 =B.unique1,Bunique2=B.unique2,Btwo=B.two,Bfour=B.four,Bten=B.ten,Btwenty= B.twenty, Bhundred=B.hundred,Bthousand=B.thousand,Btwothousand=B.twothousand,Bfivethous=B.fivethous,Btenthous=B.tenthous,Bodd=B.odd, Beven=B.even,Bstringu1=B.stringu1,Bstringu2=B.stringu2,Bstring4=B.string4) from t in tenk1, B in Bprime where t.unique2 = B.unique2
destroy temp
retrieve into temp (t.all,Bunique1 =B.unique1,Bunique2=B.unique2,Btwo=B.two,Bfour=B.four,Bten=B.ten,Btwenty= B.twenty, Bhundred=B.hundred,Bthousand=B.thousand,Btwothousand=B.twothousand,Bfivethous=B.fivethous,Btenthous=B.tenthous,Bodd=B.odd, Beven=B.even,Bstringu1=B.stringu1,Bstringu2=B.stringu2,Bstring4=B.string4) from t in tenk1, B in Bprime where t.unique2 = B.unique2